﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/
/* dbo.InsuranceType (BEGIN) */

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Preventitive Care/Wellness', 'Preventitive Care/Wellness', 'AG', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('24 Hour Care', '24 Hour Care', 'AH', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Medicare Risk', 'Medicare Risk', 'AJ', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Mental Health', 'Mental Health', 'AK', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Dental Capitation', 'Dental Capitation', 'DCP', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Dental', 'Dental', 'DEN', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Exclusive Provider Organization', 'Exclusive Provider Organization', 'EPO', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Facility', 'Facility', 'FAC', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Hearing', 'Hearing', 'HE', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Health', 'Health', 'HLT', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Health Maintenance Organization', 'Health Maintenance Organization', 'HMO', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Long-Term Care', 'Long-Term Care', 'LTC', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Long-Term Disability', 'Long-Term Disability', 'LTD', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Major Medical', 'Major Medical', 'MM', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Mail Order Drug', 'Mail Order Drug', 'MOD', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Prescription Drug', 'Prescription Drug', 'PDG', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Point of Service', 'Point of Service', 'POS', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Preferred Provider Organization', 'Preferred Provider Organization', 'PPO', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Practitioners', 'Practitioners', 'PRA', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Short-Term Disability', 'Short-Term Disability', 'STD', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Utilization Review', 'Utilization Review', 'UR', 1)

INSERT INTO InsuranceType (Name, Description, Code, Enabled)  VALUES ('Vision', 'Vision', 'VIS', 1)

/* dbo.InsuranceType ( END ) */